vignettes/higher_ed_institutions.Rmd
higher_ed_institutions.RmdAs of March 13, 2024, the Federal Statistical Office of Germany (Destatis) lists a total of 427 institutions of higher education in the country. The table below lists all these institutions, together with links providing a wide variety of further information for each institution (see documentation below).
gt Package
The data is sourced from the following tables and lists:
The key tables for the student statistics (table series 372) provided by the Federal Statistical Agency (Destatis) on its data collection portal (Erhebungsportal). There are four key tables / csv files containing data on institutions of higher education in Germany: 1.) Hochschule, 2.) HochschulStandort, 3.) HochschuleErsteinschreibung, and 4.) HochschulFachbereich, each with slight differences in how and where institutions are counted (e.g. when a university has subsidiary campuses in other cities and German states, or in the classification of university hospitals),
the list of all institutions of higher education in Germany provided by the German Rector’s Conference (HRK). The Federal Statistical Agency data together with the HRK list are the “most authoritative German numbers” that exist.
the German and English Wikipedia article for each institution,
the Wikidata entry for each institution,
Logos are sourced as data URIs from Wikimedia Commons (preferred), or from the German or English Wikipedia entry. If available, SVGs are preferred to raster formats.
as described in vignette("ror"), we use the global
Research Organization Registry (ROR) REST API to retrieve additional
data and identifiers which are then matched to the existing
data.
If available, the following identifiers for each institution are included:
the 9-digit Participant Identification Code (PIC) used in the EU Funding & Tenders Portal (Wikidata Property P5785),
the identifier for the GEPRIS database of funded research projects, published by the German Research Foundation (DFG) (Wikidata Property P4870),
the German Research Institution (GERiT) ID of each institution (see https://gerit.org/en/about),
the ID used by the German Rector’s Conference (HRK),
the Research Infrastructure for Research and Innovation Studies (RISIS) ID see https://register.orgreg.joanneum.at/#/about/1). Note that a free account is required to use their services.
the Research Organization Registry (ROR) ID (see
vignette("ror") and Wikidata Property
P6782),
the ID of the World Higher Education Database by the International Association of Universities.
If available, the following websites based on the institution’s city are linked:
the German Foreign Exchange Service page,
the CHE University Ranking page as hosted by the German Academic Exchange Service.
If available, the following websites providing further details on each instituion of higher eduation and their programs are linked:
the CHE University Ranking as hosted by the German Academic Exchange Service,
the studieren.de page,
the CHE University Ranking as hosted by ZEIT Online / Hey Studium.
If available, the following rankings are linked:
the CHE University Ranking as hosted by the German Academic Exchange Service,
the Times Higher Education Ranking (Wikidata Property P5586),
The following APIs were helpful in creating the data above:
YouYoube Data API v3 for retrieving the proper channel IDs,
Wiki Core REST API to search for Wikipedia entries and retrieve translated pages,
Wikidata SPARQL query service to obtain data from Wikidata pages (can be queried through the WikidataR package),
SOAP XML web service from Destatis to obtain data from the Federal Statistical Office of Germany (can be queried through the wiesbaden package)